package com.hnevc.mallserver3.mapper;


import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.hnevc.mallserver3.entity.Member;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
@Mapper
public interface MemberMapper extends BaseMapper<Member> {

    @Select("SELECT * FROM t_member WHERE member_phone = #{memberPhone} AND password = #{password}")
    Member selectMemberByPhoneAndPassword(@Param("memberPhone") String memberPhone,@Param("password")  String password);
    @Select("SELECT * FROM t_member WHERE username = #{username} AND password = #{password}")
    Member selectMemberByUsernameAndPassword(@Param("username") String username, @Param("password") String password);


}